-- #lazgen HEADER#
/*
	spGoalStatusGet.

	This procedure returns a single Goal Status from the database, based on a specific primary key value.
*/
SET ANSI_NULLS ON
GO

ALTER PROCEDURE [spGoalStatusGet]
(		
	@id INT

) AS
		
BEGIN
-- #endlazgen HEADER#

-- #lazgen BODY#

SELECT
	[goalstatus].[Id],
	[goalstatus].[Title],
	[goalstatus].[Description],
	[goalstatus].[Created],
	[goalstatus].[Modified]
FROM
	[tblGoalStatus] [goalstatus]
WHERE
	[goalstatus].[Id] = @id

-- #endlazgen BODY#


-- #lazgen FOOTER#

END

GO

SET ANSI_NULLS OFF
GO   
-- #endlazgen FOOTER#
